UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+zBm90DscubPsEVMPx9AIPX9qrUytyORHh8r9yn2AM='
WHERE
key_id = 'a78d58b09e02db62ca39a20de7edf76182ce8c33e93936ceea26943e3adefab3'
AND (
token = 'z+zBm90DscubPsEVMPx9AIPX9qrUytyORHh8r9yn2AM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)