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