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