UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oz9cn+c68gSkNvWHwKCL2Hlwmo3jiuMl8FE8yosYXoA='
WHERE
key_id = 'a5594e6e2349f6d7a68a2daf5d122cebdfe5abc6ba6bd1a95d1ac7618b274164'
AND (
token = 'oz9cn+c68gSkNvWHwKCL2Hlwmo3jiuMl8FE8yosYXoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)