UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '09WRzzqR+c1eUphvHtjWkOynOHMW9kNnADHVqSZV9+w='
WHERE
key_id = 'd212196b0a00ad1ec9728bc2abadd7e7b9bebd73fc407f2c219b6c0de80f659e'
AND (
token = '09WRzzqR+c1eUphvHtjWkOynOHMW9kNnADHVqSZV9+w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)