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