UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aCgR7saOAzS/q5x9acuzDL1yWHYFxj4Q8AZKAqc7XvU='
WHERE
key_id = '67a04481b044afd4a105878e2b20e18f7e975f3c019c04acb1eabb1f3936a399'
AND (
token = 'aCgR7saOAzS/q5x9acuzDL1yWHYFxj4Q8AZKAqc7XvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)