UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gXojiIWfXT5RS8HQvc9nhNcNW0h95iK2EsUe5a3ixNw='
WHERE
key_id = 'f0975d7778c11fd3675a22b90e03f94d63ab3c72b6c76a1b2d8d1ee5bfda7429'
AND (
token = 'gXojiIWfXT5RS8HQvc9nhNcNW0h95iK2EsUe5a3ixNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)