UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gWTXEp6E2nfcoKgzcOYjP0QhocFtv7iAkWsYb+YNd7w='
WHERE
key_id = '6ace218602e2baa3fd83ee9ab73e9e7675deb161db98c41eb5fff977c61b9a43'
AND (
token = 'gWTXEp6E2nfcoKgzcOYjP0QhocFtv7iAkWsYb+YNd7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)