UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n7JkaA84gMEOtxRJmRpsrI78n1gAqpkZoYjvaqTcVD8='
WHERE
key_id = 'ea152d55df3dcd35586dccbec70aecb86fcd9b41b088da2e3997fe2151ca5459'
AND (
token = 'n7JkaA84gMEOtxRJmRpsrI78n1gAqpkZoYjvaqTcVD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)