UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AwnChWDNtgD19WOpcJeL1GtH+LNZ4ikHQEPUw8oKu28='
WHERE
key_id = '78700ab189947d1afa2d92cc528a64aa2f2a81fe07c937941217169060f48117'
AND (
token = 'AwnChWDNtgD19WOpcJeL1GtH+LNZ4ikHQEPUw8oKu28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)