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