UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1plV6SzsuYoqo29NfBLsIOMoTlbCZbxWpncaWW8HNBg='
WHERE
key_id = 'aa967abb425620725e179bcf99f4678768c806cc3131d58b0edee1da266ea134'
AND (
token = '1plV6SzsuYoqo29NfBLsIOMoTlbCZbxWpncaWW8HNBg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)