UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzgtS40TklAjGPsRbQ5HCr/F08mjXxSpiz06Dem2G/A='
WHERE
key_id = '7de9eeea54c3d00aa399d426311d13604db5dade08522a63fbcfb0fdedd4d79b'
AND (
token = 'HzgtS40TklAjGPsRbQ5HCr/F08mjXxSpiz06Dem2G/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)