UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xzc1bBwZFOhlIT8H1hM3UWpGcbhoSfr6pE6J2JOAceg='
WHERE
key_id = '123e19f2d7857457490f9dcc640504bfd8b6c33a70413a3a48dac6a9882cd7ce'
AND (
token = 'xzc1bBwZFOhlIT8H1hM3UWpGcbhoSfr6pE6J2JOAceg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)