UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcvDgyAmZYrgjblZwSOUEl6GJRzy4Luz+Uq2lWd8zd8='
WHERE
key_id = 'aea5ab4fbdff9ac4d2c7f8453327af5f4fea2e48784202a5572c8e5213245a73'
AND (
token = 'BcvDgyAmZYrgjblZwSOUEl6GJRzy4Luz+Uq2lWd8zd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)