UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCnpEAAYaTp3V2pkXU+yckZCYgMxaWPgeDIJ8uhTWhM='
WHERE
key_id = '67b748c864aecfca77248c0a7d99ad76320f92b9bf57bd023cd48177709249cd'
AND (
token = 'QCnpEAAYaTp3V2pkXU+yckZCYgMxaWPgeDIJ8uhTWhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)