UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MEcceN3jAieTVuTV/atD36EIlghHdFvX98/ve21Yf4c='
WHERE
key_id = '54611188332c136f601b30523e062b515ee549217ec354daa0fe0a06b9ca8b28'
AND (
token = 'MEcceN3jAieTVuTV/atD36EIlghHdFvX98/ve21Yf4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)