UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wXGqlN7bNI4l57Vax9rlcz3zOHB5HmHrBWPCN18OrM8='
WHERE
key_id = '00c8643a8e17104f6b915709884136f765be104befd62ac8d5a11d563acf4cff'
AND (
token = 'wXGqlN7bNI4l57Vax9rlcz3zOHB5HmHrBWPCN18OrM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)