UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cNWnRCpRJ/2VBHqWRF0uEXtoowuJdX82WIJ+BXf6jso='
WHERE
key_id = 'ad49b76c5a6219e1def04eb6b2ef3170ec5f4e4ab99484ec787dd2fa4ebfb796'
AND (
token = 'cNWnRCpRJ/2VBHqWRF0uEXtoowuJdX82WIJ+BXf6jso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)