UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bx7eoCC3129ntGpkwLuXaPJ5Pynvwsm5pG6DWUCOwc4='
WHERE
key_id = '594f8118c2be1b34414f9ddf15a5a118eb4e1d0efe550e42dc584ea0d6df08a4'
AND (
token = 'bx7eoCC3129ntGpkwLuXaPJ5Pynvwsm5pG6DWUCOwc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)