UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dTY83yoi1q8zDq1T7EKOsBH5Xpfy2m38cYdybeu+sh4='
WHERE
key_id = '20f942e9381711cefd3430cac746ed9b5af713e12b197aa50ce698bfbb5cc25a'
AND (
token = 'dTY83yoi1q8zDq1T7EKOsBH5Xpfy2m38cYdybeu+sh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)