UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGnkI4AoRnOMHd3x2w9CLGATfeFP3HoycE+cePBSZps='
WHERE
key_id = 'bb8ad3200612ac6c198313c8d6c231b96c07bd27f1f93787cbff3d8929f4f0d4'
AND (
token = 'XGnkI4AoRnOMHd3x2w9CLGATfeFP3HoycE+cePBSZps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)