UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iBy1FYnS/kL2ycPizn+i5SHQjnr+SUMJuB1TMhZQaA='
WHERE
key_id = '8a5834d339faa205c515313c9b88c1ddcd76685b3d2e663f0ccd8d84e18239c3'
AND (
token = '7iBy1FYnS/kL2ycPizn+i5SHQjnr+SUMJuB1TMhZQaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)