UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qz6lpffKbSiChHFN5uW+bBvgcillPqdSGKQ+DjkxqNQ='
WHERE
key_id = 'a54bf5c8ffa3ed2969759fa3a5110247aca60b4f0c1be91f1cbb392e027ba877'
AND (
token = 'Qz6lpffKbSiChHFN5uW+bBvgcillPqdSGKQ+DjkxqNQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)