UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6DaGX5NRLhfhic9K3tCAYPnChoBoWAsL8fd+luVQig='
WHERE
key_id = 'fb7ec4d905b63f3084ef54d8d6af54b67bdd7ef2831621bfd3d848b40f7ba4f7'
AND (
token = 'o6DaGX5NRLhfhic9K3tCAYPnChoBoWAsL8fd+luVQig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)