UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAAP5i93YiZCZ+elWsk85n/tImclIdxs5K2s/O4+NZw='
WHERE
key_id = 'd548c0265e230ff739a024505396a987d52cec17cd1221ad37f74b2e6deacc49'
AND (
token = 'ZAAP5i93YiZCZ+elWsk85n/tImclIdxs5K2s/O4+NZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)