UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0KGx1pWu8XvW3L1VO3vn948eQGfKdsW6CzIBojiKAfY='
WHERE
key_id = '50bbb412723a0bbdf7faf3a5aec91844712b7def13041d9006d36c4195001ffc'
AND (
token = '0KGx1pWu8XvW3L1VO3vn948eQGfKdsW6CzIBojiKAfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)