UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asbsg8LXHbBF2i5tcTvTjNp0BHlA+bclbj95mptSWr8='
WHERE
key_id = 'e597e84537a5a6dd5948cbec91a6529c85fc7a7ceb197462fd74d6210265e8fc'
AND (
token = 'asbsg8LXHbBF2i5tcTvTjNp0BHlA+bclbj95mptSWr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)