UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Avfbme/oWUVvlCI44Ov4NA7yrOH/f274Li6+QKMYWlw='
WHERE
key_id = 'c8c29b832bc9f8e2d120cf855934e3d372f17e7905606e6f1223c1d597b91eba'
AND (
token = 'Avfbme/oWUVvlCI44Ov4NA7yrOH/f274Li6+QKMYWlw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)