UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJjjcQfD76Qv0bDD3kv+p7En9p8Wbp8JQEPrbZwwkm8='
WHERE
key_id = 'bbfb793e8201ac45eda7fc5f28b0e8a7db8809a3aaf029eb3fc78d8139216a66'
AND (
token = 'ZJjjcQfD76Qv0bDD3kv+p7En9p8Wbp8JQEPrbZwwkm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)